﻿CREATE PROCEDURE [dbo].[proc_L_Reimbursement_Item_Getlist]
	(
		@UserName VARCHAR(10)
	)
AS
Select
	Id
	,Reason
	,Prices
	,userid
	,lrrq
	,CateOneName
	, CateTwoName
	, SubjectName
	,ISNULL((SELECT COUNT(1) FROM L_Reimbursement_Assets WHERE L_Reimbursement_Assets.itemid=L_Reimbursement_Item.id),0) AS a_count
	,A_tx
	,Pjbh
	FROM L_Reimbursement_Item WHERE userid=@UserName AND Pid=0
	RETURN